/**
 * 
 */
package de.alex.schulzeit.db.teacher;

/**
 * @author Alexander Ruetz
 *
 */
public final class TeacherTable implements TeacherColumns {

	public static final String TABLE_NAME = TeacherTable.class.getSimpleName();
	
	public static final String SQL_CREATE = "CREATE TABLE " + TABLE_NAME + " (" +
			ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + 
			TEACHER_NAME + " TEXT NOT NULL);";
	
	public static final String SQL_DROP = "DROP TABLE IF EXISTS " + TABLE_NAME;
	
	public static final String SQL_DUMMY1 = "INSERT INTO " + TABLE_NAME + " (" +
		TEACHER_NAME + ") VALUES ('Testo1');";
	
	public static final String SQL_DUMMY2 = "INSERT INTO " + TABLE_NAME + " (" +
	TEACHER_NAME + ") VALUES ('Vale');";
	
	public static final String SQL_DUMMY3 = "INSERT INTO " + TABLE_NAME + " (" +
	TEACHER_NAME + ") VALUES ('Walch');";
	
	public static final String SQL_DUMMY4 = "INSERT INTO " + TABLE_NAME + " (" +
	TEACHER_NAME + ") VALUES ('Lolz');";
	
}
